Spreadsheet Computation with imprecise and uncertain Data
نویسنده
چکیده
We consider universal relations as flat tables having numeric data types which can be simply viewed as spreadsheets. The underlying stochastic model is the finite dimensional metric (Euclidean) space R backed up by the Borel set B as an adequate σ-algebra, and a related uncertainty (see Fuzzy Logic) or probability measure P, i.e. (R,B,P)as the corresponding possibility or probability space. You may consider P as the multivariate distribution on B specified by a multivariate Gaussian distribution. According to existing integrity constraints P may be lossless decomposed into a mixture of partial and marginal distributions (cf. Generalized Markov Theorem). Ex. 1: Linear component Models Aitkinson (1996) As completely tackled in science, experts in chemistry for instance sample materials, and measures the fractions (percentages) of S, SO, Fe,... Due to measurement errors such fractions never add-up to one (100%). Can one find “best” estimates of those fractions i ξ̂ (i =
منابع مشابه
Data envelopment analysis for imprecise data in Buyer-Seller Relationship
In the environment of business‐to‐business e‐commerce, Buyers and sellers in mature industrial markets can turn single transactions into long-term beneficial relationships by a deeper understanding of the complex connection between the two and buyers and sellers are uncertain about their roles. A “must-do” for the sellers, in particular, is to understand patterns of investment and reward,...
متن کاملRobust DEA under discrete uncertain data: a case study of Iranian electricity distribution companies
Crisp input and output data are fundamentally indispensable in traditional data envelopment analysis (DEA). However, the real-world problems often deal with imprecise or ambiguous data. In this paper, we propose a novel robust data envelopment model (RDEA) to investigate the efficiencies of decision-making units (DMU) when there are discrete uncertain input and output data. The method is based ...
متن کامل1 Interval Computations on the Spreadsheet
This paper reviews work on using interval arithmetic as the basis for next generation spreadsheet programs capable of dealing with rounding errors, imprecise data, and numerical constraints. A series of ever more versatile computational models for spreadsheets are presented beginning from classical interval arithmetic and ending up with interval constraint satisfaction. In order to demonstrate ...
متن کاملInterval Computations on the Spreadsheet
This paper reviews work on using interval arithmetic as the basis for next generation spreadsheet programs capable of dealing with rounding errors, imprecise data, and numerical constraints. A series of ever more versatile computational models for spreadsheets are presented beginning from classical interval arithmetic and ending up with interval constraint satisfaction. In order to demonstrate ...
متن کاملCLARO: Modeling and Processing of High-Volume Uncertain Data Streams
Uncertain data streams, where data is incomplete, imprecise, and even misleading, have been observed in a variety of environments. Feeding uncertain data streams to existing stream systems can produce results of unknown quality, which is of paramount concern to monitoring applications. In this paper, we present the Claro system that supports uncertain data stream processing for data that is nat...
متن کامل